﻿CREATE TABLE [cex].[Audit]
(
[Id] [int] NOT NULL IDENTITY(1, 1),
[UserId] [int] NOT NULL,
[AuditKey] [varchar] (50) COLLATE Latin1_General_CI_AS NOT NULL,
[StartDate] [datetime] NOT NULL,
[EndDate] [datetime] NOT NULL,
[Country] [varchar] (100) COLLATE Latin1_General_CI_AS NULL,
[State] [varchar] (100) COLLATE Latin1_General_CI_AS NULL,
[PeopleInHousehold] [int] NOT NULL,
[Created] [datetime] NOT NULL,
[Completed] bit NOT NULL,
[Deleted] [bit] NOT NULL,
[CID] [timestamp] NOT NULL
) ON [PRIMARY]


